[QUIZ] Test your understanding of SQL - Part 4

Let's try our knowledge with multiple choice questions about SQL database management system.
  1. Question 1: BETWEEN in SQL used to .?
    1. Specify a column as the primary key.
    2. Specify the tables to use.
    3. Specify a range to test.
  2. Question 2: What is the LIKE used with?
    1. WHERE clause
    2. GROUP BY clause
    3. JOIN clause
    4. ORDER BY clause
  3. Question 3: What is the ABS function in SQL used for?
    1. Returns the absolute value of the numeric expression.
    2. Returns the minimum value of the numeric expression.
    3. Returns the maximum value of a numeric expression.
    4. Returns the average of a numeric expression.
  4. Question 4: Where is not a keyword or clause in SQL?

    1. INSERT
    2. SELECT
    3. INVERT
    4. UPDATE
  5. Question 5: What is the right assertion when talking about AS in SQL?
    1. The AS clause is only used with the JOIN clause.
    2. The AS clause declares a search condition.
    3. The AS clause is used to change the name of a column in the result set or to assign a name to a derived column.
  6. Question 6: Can you use both SQL HAVING and WHERE clauses in the same SQL statement?
    1. May
    2. Can not
  7. Question 7: If no ASC or DESC is specified after the ORDER BY clause, which keyword is used by default?
    1. ASC
    2. DESC
    3. DOWN
    4. There is no default value.
  8. Question 8: What is Index in SQL?
    1. Is a database table attribute, which helps speed up the search of data in a table.
    2. Is a method to join 2 or more tables together.
    3. Function similar to Alias
  9. Question 9: Which element is behind the SELECT statement in SQL?
    1. The table name in the database will retrieve the records.
    2. List of selected columns or symbols *.
    3. JOIN clause.
  10. Question 9: What does TRANSACTION in SQL have attributes commonly abbreviated as ACID?
    1. Access. Consistency. Isolation. Data.
    2. Access. Constraint. Index. Data.
    3. Atomicity. Consistency. Isolation. Durability.
    1. Atomicity - Conservative
    2. Consistency - Consistency
    3. Isolation - Independence
    4. Durability - Sustainability
  11. Question 10: Which SQL statement selects all rows from the table named Contest, with ContestDate columns with values ​​greater than or equal to March 25, 2019?
    1. SELECT * FROM Contest WHERE ContestDate> = '03 / 25/2019 '
    2. SELECT * FROM Contest WHERE ContestDate <'03 / 25/2019 '
    3. SELECT * FROM Contest HAVING ContestDate> = '03/25/2019'
  12. Question 12: What is the keyword that determines the sort of result set retrieved in the ORDER BY clause?
    1. HIGH and LOW
    2. ASC and DESC
    3. UP and DOWN
  13. Question 12: What does SQL mean?
    1. Structured Query Language
    2. Strong Query Language
    3. Standard Query Language
    4. Strict Query Language
  14. Question 14: Which of the following SQL statements is used to select data from 2 or more tables?
    1. WHERE
    2. JOIN
    3. HAVING
  15. Question 15: Which SQL statement selects all rows from the Products table and sorts the results by ProductID column?
    1. SELECT * FROM Products ORDERED BY ProductID
    2. SELECT * FROM Products ORDER BY ProductID
    3. SELECT * FROM Products WHERE ProductID> 200
    4. SELECT ProductID FROM Products
4 ★ | 2 Vote